package com.csx.data.routing.sample.mapper;

import com.csx.data.routing.sample.entity.MonthBillEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface MonthBillsMapper {
    int deleteByPrimaryKey(Integer monthBillsId);

    int insertSelective(MonthBillEntity record);

    MonthBillEntity selectByPrimaryKey(Integer monthBillsId);

    int updateByPrimaryKeySelective(MonthBillEntity record);

    MonthBillEntity selectBySerialNumber(MonthBillEntity monthBills);

    // 定义一个返回多条数据的接口
    List<MonthBillEntity> rangeQueryByDate(@Param("sql") String sql);


}
